from google.appengine.ext import db

class inventory_material(db.Model):
  name = db.StringProperty(required=True)

  # TODO: or TextProperty()? string is <500chars, but TextProperty can't be
  # indexed or filtered or sorted.
  notes = db.StringProperty(multiline=True)

  # True if this an accord (vs a primary material -- accords are composed
  # of primary materials and other accords).
  is_accord = db.BooleanProperty(default=False)

  bottle_num = db.IntegerProperty()

  ml_on_hand = db.IntegerProperty()

  # Price per ml
  price_ml = db.FloatProperty()

  # substantivity, in hours
  substantivity = db.IntegerProperty()
